Creating Worksheets

For complex drawings, it is best to create separate worksheets for each task rather than one large worksheet. Worksheets can be linked to share data, formulas, and calculations.

Worksheets can be created in several ways. A blank worksheet can be created through the Resource Browser, and then edited to display the desired information. The Create Report command uses information already present in the drawing to create a worksheet. Worksheets can also be imported from other VectorWorks files and other spreadsheet programs.

If the same set of objects are typically used in your drawings, you can create a template file with a worksheet that serves as a “master price list” listing all the objects and their costs. Then, to create materials lists and cost estimates for a new design, simply import or reference the worksheet in the new drawing file.

To create a blank worksheet:

1.	Select Window > Palettes > Resource Browser.

2.	From the Resources menu, select New Resource to display the New Resource menu.

3.	Select Worksheet.

The Create Worksheet dialog box opens.

 

Parameter	Description
Name	Enter a worksheet name; it can be renamed later through the Resource Browser by selecting the worksheet and clicking Rename from the Resources menu
Rows / Columns	Enter the number of rows and columns for the worksheet; the number of rows and columns can be modified later

4.

Click OK.

A new worksheet window opens.

See Using Worksheets for information on how to use the worksheet.

The worksheet is saved with the file and is listed in the Resource Browser. It can also be accessed by selecting Window > Worksheets.